CREATE TABLE [dbo].[TTTIPO_INF1]
(
[TI_INF1] [dbo].[TD_VC_008] NOT NULL,
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[DE_TIPO_INF1] [dbo].[TD_VC_030] NOT NULL CONSTRAINT [DF__TTTIPO_IN__DE_TI__33F4B129] DEFAULT (' '),
[CO_SIST] [dbo].[TD_VC_008] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TTTIPO_IN__CO_US__34E8D562] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TTTIPO_IN__FE_US__35DCF99B] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TTTIPO_IN__CO_US__36D11DD4] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TTTIPO_IN__FE_US__37C5420D] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIPO_INF1] ADD CONSTRAINT [PK__TTTIPO_I__7F46AAF80C70CFB4] PRIMARY KEY CLUSTERED  ([TI_INF1], [CO_EMPR]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIPO_INF1] ADD CONSTRAINT [FK__TTTIPO_IN__CO_EM__58BC2184] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMEMPR] ([CO_EMPR])
GO
ALTER TABLE [dbo].[TTTIPO_INF1] ADD CONSTRAINT [FK__TTTIPO_IN__CO_SI__59B045BD] FOREIGN KEY ([CO_SIST]) REFERENCES [dbo].[TMSIST] ([CO_SIST])
GO
GRANT SELECT ON  [dbo].[TTTIPO_INF1] TO [public]
GRANT INSERT ON  [dbo].[TTTIPO_INF1] TO [public]
GRANT DELETE ON  [dbo].[TTTIPO_INF1] TO [public]
GRANT UPDATE ON  [dbo].[TTTIPO_INF1] TO [public]
GO
